<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>DROP TABLESPACE</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.1.2 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="SQL Commands"
HREF="sql-commands.html"><LINK
REL="PREVIOUS"
TITLE="DROP TABLE"
HREF="sql-droptable.html"><LINK
REL="NEXT"
TITLE="DROP TEXT SEARCH CONFIGURATION"
HREF="sql-droptsconfig.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2011-12-01T22:07:59"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.1.2 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="DROP TABLE"
HREF="sql-droptable.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-commands.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="DROP TEXT SEARCH CONFIGURATION"
HREF="sql-droptsconfig.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="SQL-DROPTABLESPACE"
></A
>DROP TABLESPACE</H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN71402"
></A
><H2
>Name</H2
>DROP TABLESPACE&nbsp;--&nbsp;remove a tablespace</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN71407"
></A
><H2
>Synopsis</H2
><PRE
CLASS="SYNOPSIS"
>DROP TABLESPACE [ IF EXISTS ] <TT
CLASS="REPLACEABLE"
><I
>tablespace_name</I
></TT
></PRE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71410"
></A
><H2
>Description</H2
><P
>   <TT
CLASS="COMMAND"
>DROP TABLESPACE</TT
> removes a tablespace from the system.
  </P
><P
>   A tablespace can only be dropped by its owner or a superuser.
   The tablespace must be empty of all database objects before it can be
   dropped. It is possible that objects in other databases might still reside
   in the tablespace even if no objects in the current database are using
   the tablespace.  Also, if the tablespace is listed in the <A
HREF="runtime-config-client.html#GUC-TEMP-TABLESPACES"
>temp_tablespaces</A
> setting of any active session, the
   <TT
CLASS="COMMAND"
>DROP</TT
> might fail due to temporary files residing in the
   tablespace.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71417"
></A
><H2
>Parameters</H2
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><TT
CLASS="LITERAL"
>IF EXISTS</TT
></DT
><DD
><P
>      Do not throw an error if the tablespace does not exist. A notice is issued
      in this case.
     </P
></DD
><DT
><TT
CLASS="REPLACEABLE"
><I
>tablespace_name</I
></TT
></DT
><DD
><P
>      The name of a tablespace.
     </P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71430"
></A
><H2
>Notes</H2
><P
>    <TT
CLASS="COMMAND"
>DROP TABLESPACE</TT
> cannot be executed inside a transaction block.
   </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71434"
></A
><H2
>Examples</H2
><P
>   To remove tablespace <TT
CLASS="LITERAL"
>mystuff</TT
> from the system:
</P><PRE
CLASS="PROGRAMLISTING"
>DROP TABLESPACE mystuff;</PRE
><P></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71439"
></A
><H2
>Compatibility</H2
><P
>   <TT
CLASS="COMMAND"
>DROP TABLESPACE</TT
> is a <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>
   extension.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN71444"
></A
><H2
>See Also</H2
><A
HREF="sql-createtablespace.html"
>CREATE TABLESPACE</A
>, <A
HREF="sql-altertablespace.html"
>ALTER TABLESPACE</A
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-droptable.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="sql-droptsconfig.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>DROP TABLE</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql-commands.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>DROP TEXT SEARCH CONFIGURATION</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>